Reformat data - multiple Columns to rows

Attached is a Sample of data as it currently exists and then how it is needed to be reformatted.

Each Customer Name (Source Column A) has the potential to have data in 16 columns (Columns C:R)

I need to instead have the data be potentially 16 rows for each customer. (But then if the data in row is blank, then to not show that data).

The Outcome tab of the attached sheet would show how the layout would need to be formatted.

So for example, the First name (ALL909) has data in 6 of the 16 columns. So there should only be 6 rows of data for ALL909 when it is finalized on the Outcome tab.

try this code.

Please Login or Register  to view this content.

try

Please Login or Register  to view this content.

THANK YOU ALL!!!! I will play with these and let you know if I have any questions.

Originally Posted by seercoven

try this code.

Please Login or Register  to view this content.

@Seercoven - When I try to run this code it provides an error surrounding the "Next i" command. If I try changing the "i" to an "a" it does not seem to pull through all of the needed info. Please advise.

Originally Posted by jindon

try

Please Login or Register  to view this content.

Jindon - This works really well and fast on the sample sheet. I was not expecting to have issues adapting the sample to what I needed to do for the live sheet. In reality the issue I am having is updating

Please Login or Register  to view this content.

My plan was to have essentially a vlookup in this column to look up against the value in B(n,3). How would I go about adapting that. The value would be different for each value in b(n,1), so it is dependent on all of that data.

Impossible to even guess, so upload your workbook showing how you want it.

How is the code related to your attached workbook?

No sheet named "Total", "Import", so no idea.

Ahhh so sorry. The Attached workbook has the Macro in it with correct code

So sorry again

Please Login or Register  to view this content.

See if I understand your requirement.
This is a stand alone type so, shouldn't be called from your existsing code.

Please Login or Register  to view this content.

Originally Posted by jindon

See if I understand your requirement.
This is a stand alone type so, shouldn't be called from your existsing code.

Please Login or Register  to view this content.

This is REALLLLLLLY CLOSE to what is needed. I have uploaded the file with the new code in it...

On the Outcome Tab - G7:G11 is perfect. G12 would need to update to show as "MGMT FEE - 234 - BUF282" but instead it just grabs the same reference that same "MGMT FEE - 234 - BOI716" value. So it needs to pull that updated customer name to append to the Item field, if that makes sense?



This is absolutely amazing, though, I cannot believe how fast it is!!!

Ahhh, try change

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.