hardik_088
Registered User.
- Local time
- Yesterday, 17:27
- Joined
- May 31, 2011
- Messages
- 82
i have column and row i want to change view from horizontal to vertical and vice versa
change column view (1 Viewer)
- Thread starter hardik_088
- Start date
Brianwarnock
Retired
- Local time
- Today, 01:27
- Joined
- Jun 2, 2003
- Messages
- 12,701
Lookup the Transpose function
Brian
Brian
hardik_088
Registered User.
- Local time
- Yesterday, 17:27
- Joined
- May 31, 2011
- Messages
- 82
hi
Suppose I have this
Product id | Sales
1 1500
2 1600
3 1700
I want this Way
product id 1 | 2| 3
Sales 1500|1600|1700
Suppose I have this
Product id | Sales
1 1500
2 1600
3 1700
I want this Way
product id 1 | 2| 3
Sales 1500|1600|1700
NBVC
Only trying to help
- Local time
- Yesterday, 20:27
- Joined
- Apr 25, 2008
- Messages
- 317
You can copy your current range,
Go to a cell not in that range and select Edit|Paste special and select Transpose.
Click Ok.
If you want to do it with formulas... then assuming your data is in column A:B, your formula would be:
=INDEX($A:$B,COLUMNS($A$1:A$1),ROWS($A$1:$A1))
copied down 1 row and across as many columns as the original had rows.
Go to a cell not in that range and select Edit|Paste special and select Transpose.
Click Ok.
If you want to do it with formulas... then assuming your data is in column A:B, your formula would be:
=INDEX($A:$B,COLUMNS($A$1:A$1),ROWS($A$1:$A1))
copied down 1 row and across as many columns as the original had rows.
