VBA: convert cell data to column and vice versa
Two VBA codes help required.
Example
Input in Sheet1:
column A2: Sam | Cell B1 data: a, 1Apple, Rose*
column A3: Sam | Cell B1 data: a, Rose*
Output in Sheet2:
column A2: Sam | Cell B1 data: a
column A2: Sam | Cell B1 data: 1Apple
column A2: Sam | Cell B1 data: Rose*
column A3: Sam | Cell B2 data: a
column A3: Sam | Cell B2 data: Rose*
Bookmarks