Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course

convert

0

dear all

i want convert vertical to horizontal in Excel 2013

please attachment

thanks

ira

excel
MS Office Version: 2003 and 2010
posted by: ira (rep: 2) on Thu Feb 20, 2020 at 6:47 am
Answer
Discuss

Answers

0

put the following formula in adjacent column

=+A3&"','"&A4&"','"&A5&"','"&A6&"','"&A7&"','"&A8

posted by: queue (rep: 467) on Thu Feb 20, 2020 at 8:02 am
Discuss
0
  1. Select your original data and press Ctl+C (Copy)
  2. Select a target cell (top left of the target range)
  3. From the Ribbon's Home tab, select Paste > Paste Special
  4. Checkmark Transpose and click OK
posted by: Variatus (rep: 4889) on Thu Feb 20, 2020 at 10:44 am
Discuss


Answer the Question

You must create an account to use the forum. Create an Account or Login