Hello,
I have a file that a system spits out that is somewhat useless (sample attached - first doc out of 3k). It merges the first few columns that are common to the rows and then places data into rows within a single cell. How do I go about flattening this file? I need a value in each column without the odd formatting.
I would appreciate any help.
Thank you,
Did some more research:
Basically this is a txt to row problem which is generally solved by transposing/txt to column combinations. The problem I am facing is that when there is more than one (3k in this case) of rows that need to be expanded, that work around does not work.
Thank you,
Hi,
Try the following macro. It assumes a 2nd sheet 2 with a VBA sheet code name 'Sheet2'. See file attached.
If it starts to take a long time given a much larger data set then post back and I'll modify the code so that the data is first read into a VB array and processes entirely within the VBE and written back to the sheet at the end.
Please Login or Register to view this content.
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
This is very close, but doesn't quite run the whole thing. I attached a larger sample in the doc you posted.
Hi,
See slight Mod attached
This is awesome. Looking forward to reverse engineering and learning something.
Thank you,
Glad to have helped and thanks for the rep.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks