Collecting & Grouping of Data into columns...

**Piano Man** · 02-06-2013, 02:53 AM

Greetings... to any excel enthusiasts out there.

Excel_problem.jpg

I currently have data in the Format A, but have been told I need to put it into Format B...

Is there any way to generate a new spreadsheet with the data from Format A, into Format B without having to re-type of copy???

Would would also be excellent is if I change the values in Format A, Format B also updates the changes.

Does anyone know if this can be done easily??? I only ask because my original data is far larger than the example here...

**TMS** · 02-06-2013, 03:05 AM

And, to save yourself some time, attach a sample workbook with some (more) typical data.

Regards, TMS

**samba_ravi** · 02-06-2013, 03:18 AM

Find the attachement

**:) Sixthsense :)** · 02-06-2013, 03:26 AM

In K5 cell

Formula:

Please Login or Register  to view this content.

Drag it down and right......

**Piano Man** · 02-06-2013, 04:46 AM

Damn... That was a very quick answer, and extremely helpful.

Thank you very much NFLsales... And to sixthsense - looks like Sales beat you just by a couple of minutes - but thanks for helping as well.

**vlady** · 02-06-2013, 07:59 PM

Based on your last post it seems that you are satisfied with the solution(s) you've received but you haven't marked your thread as "SOLVED".
For the meantime I'll do it for you.

How?
New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

Or you can use this way:

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save

Note:
You can also thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given.
By doing so you can add to the reputation(s) of those who helped and shared their time in helping you.