how to Change horizontal table data into vertical?

**kreesh** · 08-23-2017, 05:26 PM

Hi
I need the data from table 01 to table 02 like below.
table:01
1-Jul-17 2-Jul-17 3-Jul-17
A P P L
B P P P
C L P L

table:02
1-Jul-17 A P P L
2-Jul-17 B P P P
3-Jul-17 C L P L

**FlameRetired** · 08-23-2017, 11:33 PM

Hi kreesh. Welcome to the forum.

Try in A7 and filled down.

Formula:

Please Login or Register  to view this content.

and in B7 filled down and across.

Formula:

Please Login or Register  to view this content.

	A	B	C	D	E
1	1-Jul-17	2-Jul-17	3-Jul-17
2	A	P	P	L
3	B	P	P	P
4	C	L	P	L
5
6
7	1-Jul-17	A	P	P	L
8	2-Jul-17	B	P	P	P
9	3-Jul-17	C	L	P	L

how to Change horizontal table data into vertical?

LinkBack

Thread Tools

Rate This Thread

Display

how to Change horizontal table data into vertical?

Re: how to Change horizontal table data into vertical?

Thread Information

Users Browsing this Thread

Similar Threads

Change Vertical data to Horizontal Dimension

I want to learn how to use macros to change vertical data to horizontal data

[SOLVED] Convert horizontal data to vertical for Pivot table

Need To Change Horizontal Table to Vertical List

Excel 2007 : summing data in a table if a vertical and horizontal requirement are met

Change data from vertical to horizontal?

Reformat a vertical data set to a horizontal table

Bookmarks

Bookmarks

Posting Permissions