Hello Good People of Excel Forum,
I've attached two pictures, "CurrentData"
CurrentData.PNG
and "DesiredData."
DesiredData.PNG
Self explanatory? The problem, in simple words, is that I need to get to a sort of transposed and clean version of the original data (6000 lines).
The original data is varied so that this formula won't work:Formula:Please Login or Register to view this content.
Maybe I missed an obvious way to just transpose and VLOOKUP or copy>paste the data into a workable format, but I haven't come across a quick, macro-finish. My more recent idea was that I could insert blank rows between values in Column A until the total number of rows between each cell with data = a constant. I think 14 rows between each "Customer #" (SAMPLE1 to SAMPLE2) would give me a chance to use the formula from above:Formula:Please Login or Register to view this content.
I don't have any idea if or how this could be done. Any ideas would be great. Thanks a bunch.
Bookmarks