DATA from row to column

ADRIANA P
ADRIANA P used Ask the Experts™
on
convert data from row to one column

here the file
data_wide_to_column.xlsx
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Daniel PineaultPresident / Owner CARDA Consultants Inc.
Distinguished Expert 2018

Commented:
Use the Transpose function, or the Transpose Copy/Paste.

For the function, look over Microsoft's help on the matter as it has detailed step by step instructions, see: https://support.office.com/en-us/article/transpose-function-ed039415-ed8a-4a81-93e9-4b6dfac76027
ADRIANA PACCOUNTING ASSISTANT

Author

Commented:
Daniel Pineault  

thanks   could be ab button for ?
Excel & VBA Expert
Most Valuable Expert 2018
Awarded 2015
Commented:
Does this work as required?
Click the button called "Transpose Data" to run the code.
data_wide_to_column.xlsm
ADRIANA PACCOUNTING ASSISTANT

Author

Commented:
Perfect!

Great Expert !
Subodh Tiwari (Neeraj)Excel & VBA Expert
Most Valuable Expert 2018
Awarded 2015

Commented:
Thanks for the feedback!

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial