Macro for transposing Single Column to Rows

[ManishLC]

Hi Team,

Can you please help me with VBA code to suit my requirement.

Requirement -
Have set of Questionnaire (more than 500) in single column which has to be transposed to Rows

Example - Type of Question and Question to be added in single cell and transpose to happen in new sheet or new tab or next to the Question cell

	RAW Data	Merge and Transpose
	Procurement Processes > Question 1	Question Description	Option1	Option2	Option3	Option4	Option5	Option6	Explanation
Type of Question	Determine whether this statement is true or false.	Determine whether this statement is true or false. A plant can be assigned to several company codes.	TRUE​	FALSE​					A plant can be assigned to only one company code. At the same time, this assignment is essential. Read more in the lesson, Defining Processes and Organizational Levels
Question	A plant can be assigned to several company codes.
Explanation to Answer	A plant can be assigned to only one company code. At the same time, this assignment is essential.
	Read more in the lesson, Defining Processes and Organizational Levels
Answer, Option1	TRUE​
Option 2	FALSE​
	Procurement Processes > Question 2
	Choose the correct answer(s).	Choose the correct answer(s). Purchase order transaction is divided into which of the following screen areas?	Header data	Storage location	Item overview	Item details	Document overview	Easy Access screen	The purchase order transaction is a single-screen transaction where you can maintain all relevant data and divided into the Header, Item Overview, item Detail and Document Overview. (the storage location is an input field; )
	Purchase order transaction is divided into which of the following screen areas?
	The purchase order transaction is a single-screen transaction where you can maintain all relevant data
	and divided into the Header, Item Overview, item Detail and Document Overview. (the storage location is an
	input field; )
	Header data
	Storage location
	Item overview
	Item details
	Document overview
	Easy Access screen

It would be great if the forum provides code / support to create this macro.

Regards,

Manish

 

[OaklandJim]

Hello Manish. I would try to assist but it is challenging FOR ME to understand the data (so understanding what code must do is also challenging). Maybe show a before and after? Perhaps using Mr. Excel's addin which allows you to post parts of a worksheet. See XL2BB web page.