Convert Rows to a Table

**Seraph122** · 01-11-2013, 04:59 AM

Hi everyone,

I need help with creating a macro that basically turns the data into a pivot table - but because there are nuances and it needs to be done quickly and frequently, it has to be a macro.

If you look at the Input worksheet, you'll see the first section has the data that needs to be a table. The headers of the table are in the Output tab and they will be fixed, so they won't really change. It needs to spread the values based on the Number and Date.

The key is that there may be extra "Metrics" that don't fall into one of the headings in the Output tab - these entries can be ignored. Then there are extra headers in the "Output" tab that there may not be entries for, these can use the default table in the "Input" tab (L2:M8).

Let me know if I need to rephrase this.

As always, I really appreciate everyone's help, thank you!

**OllieB** · 01-11-2013, 06:28 AM

Hi Seraph,

Have a look at the enclosed solution. I have tried to add a lot of documentation so you will be able to maintain and adjust the solution yourself.

Run routine "BuildOutputTable"

**antoka05** · 01-11-2013, 06:50 AM

See attached file, I used this macro:

Please Login or Register  to view this content.

Regards,
Antonio

**Seraph122** · 01-11-2013, 01:34 PM

Hi both!

I'm extremely thankful for both of your quick replies! I will analyze them both as soon as I can but I wanted to say thank you!

**Seraph122** · 01-15-2013, 03:45 AM

Hi OllieB and antoka05,

Thank you greatly for your solutions, they both appear to work greatly. I might have questions in the future because my input data may change, but this certainly solves my problems for now!