7 Replies - 726 Views - Last Post: 10 January 2018 - 02:36 AM

#1 [email protected]   User is offline

  • D.I.C Head

Reputation: 0
  • View blog
  • Posts: 91
  • Joined: 16-May 17

How to customize the excel data please help me....

Posted 26 December 2017 - 09:47 AM

How to customize the excel data please help me
In the original excel sheet data show column wise. But now I want to same change to data showing structure and re arrange the data structure.
I can't upload the excel sheet that for i attached the IMG please help me

https://ibb.co/jdzC4m
Posted Image

I think it is help to understand what I say. Please help me sir please please sir

This post has been edited by modi123_1: 26 December 2017 - 09:50 AM


Is This A Good Question/Topic? 0
  • +

Replies To: How to customize the excel data please help me....

#2 modi123_1   User is online

  • Suitor #2
  • member icon



Reputation: 15359
  • View blog
  • Posts: 61,582
  • Joined: 12-June 08

Re: How to customize the excel data please help me....

Posted 26 December 2017 - 09:50 AM

Quote

. But now I want to same change to data showing structure and re arrange the data structure.

What does this mean?
Was This Post Helpful? 0
  • +
  • -

#3 [email protected]   User is offline

  • D.I.C Head

Reputation: 0
  • View blog
  • Posts: 91
  • Joined: 16-May 17

Re: How to customize the excel data please help me....

Posted 26 December 2017 - 11:00 AM

View Postmodi123_1, on 26 December 2017 - 10:20 PM, said:

Quote

. But now I want to same change to data showing structure and re arrange the data structure.

What does this mean?

I mean my original data is column "A" to "K" and row 1 is heading row 2 to 5 is data

I want set data as per column "B" to "F" and row 7 is heading and row 8 to 22 is data
I want do it using formula I have 2000+ data
But I don't know how to do this I try many things don't get the result
Please help me sir

This post has been edited by [email protected]: 26 December 2017 - 11:05 AM

Was This Post Helpful? 0
  • +
  • -

#4 modi123_1   User is online

  • Suitor #2
  • member icon



Reputation: 15359
  • View blog
  • Posts: 61,582
  • Joined: 12-June 08

Re: How to customize the excel data please help me....

Posted 26 December 2017 - 11:15 AM

Maybe try and pivot it.. or worst - just swap it all by hand.
Was This Post Helpful? 0
  • +
  • -

#5 [email protected]   User is offline

  • D.I.C Head

Reputation: 0
  • View blog
  • Posts: 91
  • Joined: 16-May 17

Re: How to customize the excel data please help me....

Posted 26 December 2017 - 11:20 AM

I have 5678 data by hand impossible
Please help me do something please sir please
Was This Post Helpful? 0
  • +
  • -

#6 modi123_1   User is online

  • Suitor #2
  • member icon



Reputation: 15359
  • View blog
  • Posts: 61,582
  • Joined: 12-June 08

Re: How to customize the excel data please help me....

Posted 26 December 2017 - 11:33 AM

There's no real slick way of automating to switch up to how ever you feel like you want it.
Was This Post Helpful? 0
  • +
  • -

#7 maceysoftware   User is offline

  • Member Title
  • member icon

Reputation: 385
  • View blog
  • Posts: 1,638
  • Joined: 07-September 13

Re: How to customize the excel data please help me....

Posted 27 December 2017 - 04:39 AM

Come now, it's not impossible to change the data by hand, it just wouldn't be cost effective or be worth your time.

There is a lot that confuses me about your desired structure, such as your Sl numbers in your desired references example doesn't match your original references, I am not sure if this is intentional or not.

For example in what you have:

SL Patients Name
1 Kanika Begum
2 Nadu Majhi
3 Purnima
4 Chand Mani Mandi

However, this is the first thing that stomps me about your desired format:

SL Patients Name
1 Kanika Begum
2 Kanika Begum
3 Nadu Majhi
4 Nadu Majhi

you also have 5 and 6 which didn't appear in the first example so I ignored them.


However, you could automate this to a certain amount by using a VBA Script or even reading this into an application, reformatting the data and rewriting the data.

Effectively let's break this down into one line at a time, reading from the first line we know:

sl
date
v_NO


We know this will always stay the same, while we are processing this line at least:

Next check to see a value is in total charge, yes? then insert a line:
SL; Date; Concat the patient's name + and procedure description, Amount; V_no

Next check to see if there is a value in HOSPITAL BILL(RSBY)--EYE, yes? Then insert another line:
SL; Date; HOSPITAL BILL(RSBY)--EYE, HOSPITAL BILL(RSBY)--EYE (value this time); V_no

Next check to see if there is a value in Medicine Bill Amount, yes? Then insert another line:
SL; Date; Medicine Bill Amount, Medicine Bill Amount; V_no

This would work for the first line, for the first half of the desired format, however, I am then struggling to work out what extra information the next two lines give you in the desired format, you would need to format them, however, again there isn't enough information as to why the first three lines are purple.
Was This Post Helpful? 0
  • +
  • -

#8 deepvyas   User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 10
  • Joined: 20-May 17

Re: How to customize the excel data please help me....

Posted 10 January 2018 - 02:36 AM

Hi Jayanta,
I can help you re-order the data "I have" into "I Want".
Please share details
Was This Post Helpful? 0
  • +
  • -

Page 1 of 1