Forum Discussion
EXCEL
I WANT TO TRANSPOSE RECORDS IN A SINGLE COLUMN TO BE IN ROWS IN EXCEL EACH RECORD IS 15 ROWS LONG I HAVE DONE THE FIRST 3 IN MY DEMO FILE I DO NOT WANT TO DO THEM ONE AT A TIME !!!! ITS TO TEDIOUS...
Easily, you can use the TRANSPOSE function
Let say you have the following data in Column A1 to A5: 299, 538, 281, 853, 843 respectively and you want to transpose all of them to be in B1 to B5
1. Select B1: B5
2. Type in =TRANSPOSE(
3. Select A1 to A5
4. Hit the CTRL + SHIFT + Enter...
You have the data transposed. Just apply the same steps in your data and you get the result.
If this reply answers your question, kindly do accept as the Best Response 😀
Let say you have the following data in Column A1 to A5: 299, 538, 281, 853, 843 respectively and you want to transpose all of them to be in B1 to B5
1. Select B1: B5
2. Type in =TRANSPOSE(
3. Select A1 to A5
4. Hit the CTRL + SHIFT + Enter...
You have the data transposed. Just apply the same steps in your data and you get the result.
If this reply answers your question, kindly do accept as the Best Response 😀