How to convert flatten table to 2D Excel table

**martinkabe** · 10-14-2015, 10:17 AM

Hi experts, I have a "flatten" table with countries and years in Excel. eg.

Country Year Value
USA 1961 a
USA 1962 x
USA 1963 g
USA 1964 y
France 1961 u

...

And I'd like to have a two dimensional table as following:

1961 1962 1963 1964
USA a x g y
France u e h a
Germany o x n p

Do you happen to know, how to do that programmatically in Excel using VBA. Many thanks in forward for any hint or advice.

**karedog** · 10-14-2015, 09:19 PM

Maybe :

Please Login or Register  to view this content.

**martinkabe** · 10-15-2015, 03:15 AM

Coool, thanks a lot.

**karedog** · 10-15-2015, 07:22 AM

You are welcome, and don't forget to mark this thread as solved, look here on how to do it :
http://www.excelforum.com/non-englis...as-solved.html

Regards

How to convert flatten table to 2D Excel table

LinkBack

Thread Tools

Rate This Thread

Display

How to convert flatten table to 2D Excel table

Re: How to convert flatten table to 2D Excel table

Re: How to convert flatten table to 2D Excel table

Re: How to convert flatten table to 2D Excel table

Thread Information

Users Browsing this Thread

Similar Threads

Convert a mutli colum Multi roy table to a 3 column table

flatten a crosstab table to list table

[SOLVED] Convert table with multiple header columns into a pivotable table

Make a table "flatten" prepare to insert in database

[SOLVED] Flatten cross table with multiple rows

What is the best way to convert an excel table into something like this?

[SOLVED] Convert Pivot Table to Normal Data table

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions