I need to convert the following data
ID Code Amount
1 REG 20
1 VAC 30
2 REG 40
2 O/T 10
3 VAC 15
3 REG 25
3 O/T 35
To the following Format
Name Code1 amount1 code2 amount2 code3 amount3
1 REG 20 VAC 30
2 REG 40 O/T 10
3 VAC 15 REG 25 O/T 35
I need to convert the following data
ID Code Amount
1 REG 20
1 VAC 30
2 REG 40
2 O/T 10
3 VAC 15
3 REG 25
3 O/T 35
To the following Format
Name Code1 amount1 code2 amount2 code3 amount3
1 REG 20 VAC 30
2 REG 40 O/T 10
3 VAC 15 REG 25 O/T 35
Hello reuven,
Welcome to Excelforum. Be a part of large Excel community. Enjoy Learning.
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
Hi reuven
Welcome to Excel Forum
This is just the Sub Forum to say hello
Start here, https://www.excelforum.com/ , then look for an appropriate Sub Forum to post your question in:
You must start a new Thread here if you need help:
http://www.excelforum.com/excel-general/
or here:
http://www.excelforum.com/excel-formulas-and-functions/
or if you would consider a macro solution then here:
http://www.excelforum.com/excel-programming-vba-macros/
If you are not sure, then probably the first will do
http://www.excelforum.com/excel-general/
_............................................
Please, also, if you get time, take some time before posting to read the Forum Rules here
http://www.excelforum.com/forum-rule...rum-rules.html
http://www.excelforum.com/forums-rules/
http://www.excelforum.com/developmen...ml#post4606484
It is usually worth it in the long run.
Thanks
Alan
'_- Google first, like this _ site:ExcelForum.com Gamut
Use Code Tags: Highlight code; click on the # icon above,
Post screenshots COPYABLE to a Spredsheet; NOT IMAGES PLEASE
http://www.excelforum.com/the-water-...ml#post4109080
https://app.box.com/s/gjpa8mk8ko4vkwcke3ig2w8z2wkfvrtv
http://excelmatters.com/excel-forums/ ( Scrolll down to bottom )
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks