Arange Imported Data

[magicool]

Hello,
I need your help, if possible, to arange the data I imported. I can not find a pattern in my imported data to work with it. That is why I need the data from "IMPORTED DATA" aranged automaticaly just like in the "RESULTS" example.
Please check the attach.
Thank you in advance for any ideea you may have!

[JBeaucaire]

based on your imported data, this will create your results on Sheet2:

Please Login or Register  to view this content.

How/Where to install the macro:

1. Open up your workbook
2. Get into VB Editor (Press Alt+F11)
3. Insert a new module (Insert > Module)
4. Copy and Paste in your code (given above)
5. Get out of VBA (Press Alt+Q)
6. Save as a macro-enabled workbook

The macro is installed and ready to use. Press Alt-F8 and select CreateSummary from the macro list.

[magicool]

Hello,
Thank You for the code! I could not do this in a million years .
Is it possible to get the results in the same sheet? I have a lot of sheets in the workbook, so it would be great to see the results in the same sheet, near the imported data. From there I'll take the data with vlookup and place it where is needed.

Thank You!

[JBeaucaire]

Try this, it will operate on whatever the activesheet is.

Please Login or Register  to view this content.

[JBeaucaire]

...and this version will cycle through every sheet in a workbook and try to create your summary for each sheet...you did say you had a bunch of sheets to do, this will attempt to do them all at once. It will function on any sheet that has IMPORTED DATA in cell D1.

Please Login or Register  to view this content.

[magicool]

Thank You so much!
I wish I could understand the code so I can modify it in the future. But for now it works perfect.

[JBeaucaire]

I've added commentary to help explain what each section of code is doing, download the code again from post #5.