Convert 1 List into 5 and Convert 5 lists into 1

Hello all, i have 2 situations.

I need to Convert 5 lists with named ranges into 1
List1 = A2:A50
List2 = B2:B50
...
...
List5 = E2:E50

Get totalList in L Column
What's the formule i put in F columns
I have this for 2 lists:

Please Login or Register  to view this content.

And other issue is to convert 1 ListTotal Into 5
ListTotal = F2;F200

Separated for types.
A 1
A 2
A 3
B 1
B 5
B 10
C 51
C 12412
D 1424
E 141
E 12

I need to split this to several columns, 1 for type A , 1 for type B, etc etc

Hope you can understand.

Thanks for your help in advance

You get better help on your question if you add a small excel file, without confidential information.

Please also add manualy the expected result in your file.

I didn't download your file.

I posted a reply at your other thread:

http://www.excelforum.com/excel-form...-into-1-a.html

However, at the time of this posting the site seems to be having trouble and I can't see my post!

Originally Posted by Tony Valko

I didn't download your file.

I posted a reply at your other thread:

http://www.excelforum.com/excel-form...-into-1-a.html

However, at the time of this posting the site seems to be having trouble and I can't see my post!

Thanks for your response. This is not exactly the same case as other thread. This one i need 2 things and with several columns probably i need to use other things..
But to solve the 5 into 1 i think i just need to create more dynamic ranges for colors and codes right?

But is there a way to convert 1 pack pf columns into 5? I mean... Doing the inverse?

Would be great if you help me out on how to convert 3 columns shown in example. If you need more information let me know

with a helpcolumn in A (see the yellow cells).

After that I added the blue cells (H2 and L2).

After that a VLookup (see the green cells).

See the attached file.

or use a pivot table

You're welcome. We appreciate the feedback!