Puzzler

tljenkin

tljenkin

Board Regular
Joined
Jun 14, 2007
Messages
147
I have a record thus:


Name Tag Week 1 Week 2

Peter hsdk £5 £10

How do I transpose this automatically so that I get the following results:

Week Name Tag Amount

Week 1 Peter hsdk £5
Week 2 Peter hsdk £10

Thanks
 
Sort by date Sort by votes

Excel Facts

VLOOKUP to Left?
Use =VLOOKUP(A2,CHOOSE({1,2},$Z$1:$Z$99,$Y$1:$Y$99),2,False) to lookup Y values to left of Z values.
Thanks

Just tested this. Can this be adjusted to reflect the following please:

1) It looks at cells A1:J1 and uses the column labels in there instead of having to type each one into the code.

2) It sets column K as the amount column

3) Then it flips columns L to IU representing 244 weeks into row records as was previously done

4) The amounts in column K do not need to be monetary, formatting with no decimal places is ok

I wish I could tweak your code myself but this is well above my grade. I am learning everyday.

Many Many Thanks
 
Upvote 0
tljenkin,

The only way we are going to get it right is if we can see your raw data.


You will generally get much more help (and faster) in this forum if you can post your small samples (sensitive data scrubbed/removed/changed) (what you have and what you expect to achieve) directly in the forum.

To attach screenshots, see below in my Signature block: Post a screen shot with one of these:

If you are not able to give us screenshots, see below in my Signature block: You can upload your workbook to Box Net, mark the workbook for sharing, and provide us with a link to your workbook.
 
Upvote 0
Here is Graphics as instructed, thanks :)
Excel Workbook
ABCDEFGHIJKLM
1CURRENTLY IS
2Row Label 1Row Label 2Row Label 3Row Label 4Row Label 5Row Label 6Row Label 7Row Label 8Row Label 9Row Label 10Row Label 11Week1 >>> 244 (244 columns)
3Record 1Record 1Record 1Record 1Record 1Record 1Record 1Record 1Record 1Record 1Record 1Record 1
4Record 2Record 2Record 2Record 2Record 2Record 2Record 2Record 2Record 2Record 2Record 2Record 2
5
6WANT IT TO BE:
7WeekRow Label 2Row Label 3Row Label 4Row Label 5Row Label 6Row Label 7Row Label 8Row Label 9Row Label 10Row Label 11Placeholder 1 >>> 7 (7 extra columns)Amount
8Week1Record 1Record 1Record 1Record 1Record 1Record 1Record 1Record 1Record 1Record 1Record 1Record 1
9Week2Record 1Record 1Record 1Record 1Record 1Record 1Record 1Record 1Record 1Record 1Record 1Record 1
10Week3Record 1Record 1Record 1Record 1Record 1Record 1Record 1Record 1Record 1Record 1Record 1Record 1
11Week4Record 1Record 1Record 1Record 1Record 1Record 1Record 1Record 1Record 1Record 1Record 1Record 1
12Week5Record 1Record 1Record 1Record 1Record 1Record 1Record 1Record 1Record 1Record 1Record 1Record 1
13Week6Record 1Record 1Record 1Record 1Record 1Record 1Record 1Record 1Record 1Record 1Record 1Record 1
14Week7Record 1Record 1Record 1Record 1Record 1Record 1Record 1Record 1Record 1Record 1Record 1Record 1
15Week8Record 1Record 1Record 1Record 1Record 1Record 1Record 1Record 1Record 1Record 1Record 1Record 1
16Week9Record 1Record 1Record 1Record 1Record 1Record 1Record 1Record 1Record 1Record 1Record 1Record 1
176Record 1Record 1Record 1Record 1Record 1Record 1Record 1Record 1Record 1Record 1Record 1Record 1
18Week 244Record 1Record 1Record 1Record 1Record 1Record 1Record 1Record 1Record 1Record 1Record 1Record 1
19Week1Record 2Record 2Record 2Record 2Record 2Record 2Record 2Record 2Record 2Record 2Record 2Record 2
Sheet1
Excel 2010
 
Last edited:
Upvote 0
tljenkin,,

Thanks for the confusing screenshots.

Can we have a screenshot of worksheet Sheet1 as is (without instructions rows), with live data (similar to your first post) (with sensitive data changed), for just two rows?


And, can we have a screenshot of worksheet Results without instructions rows/columns?

What does this mean "Placeholder 1 >>> 7 (7 extra columns)"?
 
Last edited:
Upvote 0
What shee 1 is at the moment, note can only do 13 columns so weeks 1 to 244 is shown on one column at the end
Excel Workbook
ABCDEFGHIJKL
2SeqUniqueTypeRegimeCohortHeritageProd AreaChannelPro/ReDirect/CMCTotal ComplaintsWeek1 >>> 244 (244 columns)
311BudgetICOBSLTSB - Loans - RetailLTSBLoansRetailProactiveDirect0500
422BudgetICOBSHBOS - Loans - RetailHBOSLoansRetailProactiveDirect0456
Sheet1
Excel 2010


hiker95 said:
tljenkin,,

Thanks for the confusing screenshots.

Can we have a screenshot of worksheet Sheet1 as is (without instructions rows), with live data (similar to your first post) (with sensitive data changed), for just two rows?


And, can we have a screenshot of worksheet Results without instructions rows/columns?

What does this mean "Placeholder 1 >>> 7 (7 extra columns)"?
Click to expand...
 
Upvote 0
Excel Workbook
ABCDEFGHIJKL
7WeekSeqUniqueTypeRegimeCohortHeritageProd AreaChannelPro/ReDirect/CMCAmount = Total complaints
8Week111BudgetICOBSLTSB - Loans - RetailLTSBLoansRetailProactiveDirect500
9Week222BudgetICOBSHBOS - Loans - RetailHBOSLoansRetailProactiveDirect
Sheet1
Excel 2010
 
Upvote 0
You must log in or register to reply here.

Similar threads

M
  • Question Question
Hit a wall with aggregate function
Replies
0
Views
102
MZING81
M
R
  • Question Question
Auto deleting a date column once the date has passed via VBA
Replies
4
Views
83
RMH2024
R
R
  • Question Question
Looking for help w Excel formula
Replies
2
Views
104
Dave Patton
D
P
  • Solved
Macro Coding Help
Replies
5
Views
126
Joe4
Joe4
J
  • Question Question
VBA - Copy Data Range without giving exact location to another sheet
Replies
1
Views
217
Anthony47
A

Forum statistics

Threads
1,224,552
Messages
6,179,488
Members
452,917
Latest member
MrsMSalt

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