How to customize excel data please help me

Question

1.00/5 (1 vote)

See more:

How to customize excel data please help me
sl date v_No Patient Name HOSPITAL BILL (RSBY)--EYE Medicine Bill Amount Total Charge Total Discount BY(JV-1) TO(JV-2) NEW REF(JV-2)
1 01/04/2017 2017/0001 KANIKA BEGUM(EYE) 5000 1000 6000 0 HOSPITAL BILL (RSBY)--EYE R.S.B.Y. MEDICINE BILL (RSBY)
2 02/04/2017 2017/0002 NADU MAJHI (EYE) 6000 0 6000 0 HOSPITAL BILL (RSBY)--EYE R.S.B.Y. MEDICINE BILL (RSBY)
3 03/04/2017 2017/0003 PURNIMA (EYE) 6000 0 6000 0 HOSPITAL BILL (SS)--EYE S.S MEDICINE BILL (SS)
4 04/04/2017 2017/0004 CHAND MANI MANDI (EYE0 6000 0 6000 0 HOSPITAL BILL (SS)--EYE S.S MEDICINE BILL (SS)

sl date name amount v_No
1 01/04/2017 KANIKA BEGUM(EYE)-4 -6000.00 2017/0001
1 HOSPITAL BILL (RSBY)--EYE 5000.00 2017/0001
1 MEDICINE BILL (RSBY) 1000.00 2017/0001
2 01/04/2017 R.S.B.Y. -6000.00 0001
2 KANIKA BEGUM(EYE)-4 6000.00 0001
3 02/04/2017 NADU MAJHI (EYE) -6000.00 2017/0002
3 HOSPITAL BILL (RSBY)--EYE 6000.00 2017/0002
3 MEDICINE BILL (RSBY) - 2017/0002
4 02/04/2017 R.S.B.Y. -6000.00 0002
4 NADU MAJHI (EYE) 6000.00 0002
5 03/04/2017 PURNIMA (EYE) 6000.00 2017/0003
5 HOSPITAL BILL (SS)--EYE 6000.00 2017/0003
5 MEDICINE BILL (SS) - 2017/0003
6 S.S -6000.00 0003
6 PURNIMA (EYE) 6000.00 0003
E

What I have tried:

Capture — imgbb.com[^]

Posted 26-Dec-17 3:38am

Jayanta Modak

Updated 28-Dec-17 9:42am

OriginalGriff

Add a Solution

Comments

Richard MacCutchan 26-Dec-17 12:07pm

What do you mean by "customize"?

Jayanta Modak 26-Dec-17 13:10pm

Yes sir
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
I hope if you see the attachment pictures then you understand what I want to say
I don't know good english.
Please forgive me

Richard MacCutchan 26-Dec-17 13:15pm

Sorry but that does not make things any clearer.

Jayanta Modak 26-Dec-17 13:23pm

Sir what you want to know about the attached document

Richard MacCutchan 26-Dec-17 13:27pm

It sounds like you need to look at Make summarizing and reporting easy with Excel PivotTables - TechRepublic[^]

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

ZurdoDev · Answer 1 · 2017-12-28T09:42:00

Solution 1

You can record a macro copying and pasting the data similar to what you want and then go and edit the code to loop through and automate the process.

Posted 28-Dec-17 9:42am

ZurdoDev