Transpose multiple header into columns details

J

jozpin

New Member
Joined
Aug 23, 2015
Messages
2
Hi I have huge database with 3 rows header and I need to transpose it to columns for me to be able to create a header and detail tables
 

Excel Facts

Highlight Duplicates
Home, Conditional Formatting, Highlight Cells, Duplicate records, OK to add pink formatting to any duplicates in selected range.
Sort by date Sort by votes
Please show and example of before and after so that we have a clear understanding of your needs.
 
Upvote 0
alansidman said:
Please show and example of before and after so that we have a clear understanding of your needs.
Click to expand...

Than you so much for your reply.
Below is what I want..


FROM
APPLEAPPLEBANANABANANA
GREENGREENYELLOWYELLOW
STORE NO.APPLE1APPLE2BANANA1BANANA2
1011 11
1021221
TO
STORE NODESC1DESC2DESC3QTY
101APPLEGREENAPPLE 11
101BANANAYELLOWBANANA11
101BANANAYELLOWBANANA21
102APPLEGREENAPPLE 11
102APPLEGREENAPPLE 22
102BANANAYELLOWBANANA12
102BANANAYELLOWBANANA21

<colgroup><col><col span="3"><col></colgroup><tbody>
</tbody>
 
Upvote 0
You must log in or register to reply here.

Similar threads

V
  • Question
Help Needed for a Macro to Transpose
Replies
6
Views
135
alansidman
A
M
  • Question
Stack/Combine multiple columns into one column
Replies
4
Views
101
myall_blues
myall_blues
Knockoutpie
  • Solved
Transpose cells in a column if adjacent criteria matches
Replies
5
Views
94
Fluff
Fluff
gheyman
  • Solved
Comparing two columns
Replies
6
Views
143
KRice
K
A
  • Solved
Transpose column header and insert same row for the column header
Replies
8
Views
463
askall1000
A

Forum statistics

Threads
1,214,641
Messages
6,120,695
Members
448,979
Latest member
DET4492

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top