Pivot/Transpose from Rows of multiple duplicates with columns to single rows

B

Bushranger

New Member
Joined
Mar 12, 2019
Messages
5
I have two issues I'm trying to solve

1: I have this:
[TABLE="width: 500"]
<tbody>[TR]
[TD]Doug[/TD]
[TD]Before[/TD]
[TD]7[/TD]
[/TR]
[TR]
[TD]Doug[/TD]
[TD]During[/TD]
[TD]4[/TD]
[/TR]
[TR]
[TD]Doug[/TD]
[TD]After[/TD]
[TD]9[/TD]
[/TR]
[TR]
[TD]Jim[/TD]
[TD]Before[/TD]
[TD]3[/TD]
[/TR]
[TR]
[TD]Jim[/TD]
[TD]During[/TD]
[TD]7[/TD]
[/TR]
[TR]
[TD]Jim[/TD]
[TD]After[/TD]
[TD]4[/TD]
[/TR]
[TR]
[TD]Karen[/TD]
[TD]Before[/TD]
[TD]3[/TD]
[/TR]
[TR]
[TD]Karen[/TD]
[TD]After[/TD]
[TD]6[/TD]
[/TR]
</tbody>[/TABLE]

And need it to look like this
[TABLE="width: 500"]
<tbody>[TR]
[TD]Name[/TD]
[TD]Before[/TD]
[TD]During[/TD]
[TD]After[/TD]
[/TR]
[TR]
[TD]Doug[/TD]
[TD]7[/TD]
[TD]4[/TD]
[TD]9[/TD]
[/TR]
[TR]
[TD]Jim[/TD]
[TD]3[/TD]
[TD]7[/TD]
[TD]4[/TD]
[/TR]
[TR]
[TD]Karen[/TD]
[TD]3[/TD]
[TD][/TD]
[TD]6[/TD]
[/TR]
</tbody>[/TABLE]

2. I have this
[TABLE="width: 500"]
<tbody>[TR]
[TD]Sally[/TD]
[TD]Yellow[/TD]
[/TR]
[TR]
[TD]Sally[/TD]
[TD]Blue[/TD]
[/TR]
[TR]
[TD]Sally[/TD]
[TD]Green[/TD]
[/TR]
[TR]
[TD]Jenny[/TD]
[TD]Red[/TD]
[/TR]
[TR]
[TD]Jenny[/TD]
[TD]Green[/TD]
[/TR]
[TR]
[TD]Dory[/TD]
[TD]Green[/TD]
[/TR]
[TR]
[TD]Dory[/TD]
[TD]Blue[/TD]
[/TR]
</tbody>[/TABLE]
and need it to look like this
[TABLE="width: 500"]
<tbody>[TR]
[TD]Sally[/TD]
[TD]Yellow[/TD]
[TD]Blue[/TD]
[TD]Green[/TD]
[/TR]
[TR]
[TD]Jenny[/TD]
[TD]Red[/TD]
[TD]Green[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Dory[/TD]
[TD]Green[/TD]
[TD]Blue[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

Any help appreciated. I don't know much about VBA, Pivot etc but can follow instructions very well.
 

Excel Facts

What does custom number format of ;;; mean?
Three semi-colons will hide the value in the cell. Although most people use white font instead.
Sort by date Sort by votes
using PowerQuery (Get&Transform)

[Table="width:, class:head"]
[tr=bgcolor:#FFFFFF][td=bgcolor:#5B9BD5]Name[/td][td=bgcolor:#5B9BD5]sth1[/td][td=bgcolor:#5B9BD5]Sth2[/td][td][/td][td=bgcolor:#70AD47]Name[/td][td=bgcolor:#70AD47]Before[/td][td=bgcolor:#70AD47]During[/td][td=bgcolor:#70AD47]After[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#DDEBF7]Doug[/td][td=bgcolor:#DDEBF7]Before[/td][td=bgcolor:#DDEBF7]
7​
[/td][td][/td][td=bgcolor:#E2EFDA]Doug[/td][td=bgcolor:#E2EFDA]
7​
[/td][td=bgcolor:#E2EFDA]
4​
[/td][td=bgcolor:#E2EFDA]
9​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td]Doug[/td][td]During[/td][td]
4​
[/td][td][/td][td]Jim[/td][td]
3​
[/td][td]
7​
[/td][td]
4​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#DDEBF7]Doug[/td][td=bgcolor:#DDEBF7]After[/td][td=bgcolor:#DDEBF7]
9​
[/td][td][/td][td=bgcolor:#E2EFDA]Karen[/td][td=bgcolor:#E2EFDA]
3​
[/td][td=bgcolor:#E2EFDA][/td][td=bgcolor:#E2EFDA]
6​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td]Jim[/td][td]Before[/td][td]
3​
[/td][td][/td][td][/td][td][/td][td][/td][td][/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#DDEBF7]Jim[/td][td=bgcolor:#DDEBF7]During[/td][td=bgcolor:#DDEBF7]
7​
[/td][td][/td][td][/td][td][/td][td][/td][td][/td][/tr]

[tr=bgcolor:#FFFFFF][td]Jim[/td][td]After[/td][td]
4​
[/td][td][/td][td][/td][td][/td][td][/td][td][/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#DDEBF7]Karen[/td][td=bgcolor:#DDEBF7]Before[/td][td=bgcolor:#DDEBF7]
3​
[/td][td][/td][td][/td][td][/td][td][/td][td][/td][/tr]

[tr=bgcolor:#FFFFFF][td]Karen[/td][td]After[/td][td]
6​
[/td][td][/td][td][/td][td][/td][td][/td][td][/td][/tr]

[tr=bgcolor:#FFFFFF][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#5B9BD5]Name[/td][td=bgcolor:#5B9BD5]Color[/td][td][/td][td][/td][td=bgcolor:#70AD47]Name[/td][td=bgcolor:#70AD47]Color.1[/td][td=bgcolor:#70AD47]Color.2[/td][td=bgcolor:#70AD47]Color.3[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#DDEBF7]Sally[/td][td=bgcolor:#DDEBF7]Yellow[/td][td][/td][td][/td][td=bgcolor:#E2EFDA]Sally[/td][td=bgcolor:#E2EFDA]Yellow[/td][td=bgcolor:#E2EFDA]Blue[/td][td=bgcolor:#E2EFDA]Green[/td][/tr]

[tr=bgcolor:#FFFFFF][td]Sally[/td][td]Blue[/td][td][/td][td][/td][td]Jenny[/td][td]Red[/td][td]Green[/td][td][/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#DDEBF7]Sally[/td][td=bgcolor:#DDEBF7]Green[/td][td][/td][td][/td][td=bgcolor:#E2EFDA]Dory[/td][td=bgcolor:#E2EFDA]Green[/td][td=bgcolor:#E2EFDA]Blue[/td][td=bgcolor:#E2EFDA][/td][/tr]

[tr=bgcolor:#FFFFFF][td]Jenny[/td][td]Red[/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#DDEBF7]Jenny[/td][td=bgcolor:#DDEBF7]Green[/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][/tr]

[tr=bgcolor:#FFFFFF][td]Dory[/td][td]Green[/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#DDEBF7]Dory[/td][td=bgcolor:#DDEBF7]Blue[/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][/tr]
[/table]

first case:
Code: 
[SIZE=1]let
    Source = Excel.CurrentWorkbook(){[Name="Table12"]}[Content],
    #"Pivoted Column" = Table.Pivot(Source, List.Distinct(Source[sth1]), "sth1", "Sth2", List.Sum)
in
    #"Pivoted Column"[/SIZE]
second case:
Code: 
[SIZE=1]let
    Source = Excel.CurrentWorkbook(){[Name="Table14"]}[Content],
    #"Grouped Rows" = Table.Group(Source, {"Name"}, {{"Count", each _, type table}}),
    #"Added Custom" = Table.AddColumn(#"Grouped Rows", "Color", each Table.Column([Count],"Color")),
    #"Extracted Values" = Table.TransformColumns(#"Added Custom", {"Color", each Text.Combine(List.Transform(_, Text.From), ","), type text}),
    #"Split Column by Delimiter" = Table.SplitColumn(#"Extracted Values", "Color", Splitter.SplitTextByDelimiter(",", QuoteStyle.Csv), {"Color.1", "Color.2", "Color.3"})
in
    #"Split Column by Delimiter"[/SIZE]
 
Upvote 0
sandy666 said:
using PowerQuery (Get&Transform)

[TABLE="class: head"]
<tbody>[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD="bgcolor: #5B9BD5"][COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]Name[/COLOR][/TD]
[TD="bgcolor: #5B9BD5"][COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]sth1[/COLOR][/TD]
[TD="bgcolor: #5B9BD5"][COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]Sth2[/COLOR][/TD]
[TD][/TD]
[TD="bgcolor: #70AD47"][COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]Name[/COLOR][/TD]
[TD="bgcolor: #70AD47"][COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]Before[/COLOR][/TD]
[TD="bgcolor: #70AD47"][COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]During[/COLOR][/TD]
[TD="bgcolor: #70AD47"][COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]After[/COLOR][/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD="bgcolor: #DDEBF7"]Doug[/TD]
[TD="bgcolor: #DDEBF7"]Before[/TD]
[TD="bgcolor: #DDEBF7"]
7​
[/TD]
[TD][/TD]
[TD="bgcolor: #E2EFDA"]Doug[/TD]
[TD="bgcolor: #E2EFDA"]
7​
[/TD]
[TD="bgcolor: #E2EFDA"]
4​
[/TD]
[TD="bgcolor: #E2EFDA"]
9​
[/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD]Doug[/TD]
[TD]During[/TD]
[TD]
4​
[/TD]
[TD][/TD]
[TD]Jim[/TD]
[TD]
3​
[/TD]
[TD]
7​
[/TD]
[TD]
4​
[/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD="bgcolor: #DDEBF7"]Doug[/TD]
[TD="bgcolor: #DDEBF7"]After[/TD]
[TD="bgcolor: #DDEBF7"]
9​
[/TD]
[TD][/TD]
[TD="bgcolor: #E2EFDA"]Karen[/TD]
[TD="bgcolor: #E2EFDA"]
3​
[/TD]
[TD="bgcolor: #E2EFDA"][/TD]
[TD="bgcolor: #E2EFDA"]
6​
[/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD]Jim[/TD]
[TD]Before[/TD]
[TD]
3​
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD="bgcolor: #DDEBF7"]Jim[/TD]
[TD="bgcolor: #DDEBF7"]During[/TD]
[TD="bgcolor: #DDEBF7"]
7​
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD]Jim[/TD]
[TD]After[/TD]
[TD]
4​
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD="bgcolor: #DDEBF7"]Karen[/TD]
[TD="bgcolor: #DDEBF7"]Before[/TD]
[TD="bgcolor: #DDEBF7"]
3​
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD]Karen[/TD]
[TD]After[/TD]
[TD]
6​
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD="bgcolor: #5B9BD5"][COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]Name[/COLOR][/TD]
[TD="bgcolor: #5B9BD5"][COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]Color[/COLOR][/TD]
[TD][/TD]
[TD][/TD]
[TD="bgcolor: #70AD47"][COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]Name[/COLOR][/TD]
[TD="bgcolor: #70AD47"][COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]Color.1[/COLOR][/TD]
[TD="bgcolor: #70AD47"][COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]Color.2[/COLOR][/TD]
[TD="bgcolor: #70AD47"][COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]Color.3[/COLOR][/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD="bgcolor: #DDEBF7"]Sally[/TD]
[TD="bgcolor: #DDEBF7"]Yellow[/TD]
[TD][/TD]
[TD][/TD]
[TD="bgcolor: #E2EFDA"]Sally[/TD]
[TD="bgcolor: #E2EFDA"]Yellow[/TD]
[TD="bgcolor: #E2EFDA"]Blue[/TD]
[TD="bgcolor: #E2EFDA"]Green[/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD]Sally[/TD]
[TD]Blue[/TD]
[TD][/TD]
[TD][/TD]
[TD]Jenny[/TD]
[TD]Red[/TD]
[TD]Green[/TD]
[TD][/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD="bgcolor: #DDEBF7"]Sally[/TD]
[TD="bgcolor: #DDEBF7"]Green[/TD]
[TD][/TD]
[TD][/TD]
[TD="bgcolor: #E2EFDA"]Dory[/TD]
[TD="bgcolor: #E2EFDA"]Green[/TD]
[TD="bgcolor: #E2EFDA"]Blue[/TD]
[TD="bgcolor: #E2EFDA"][/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD]Jenny[/TD]
[TD]Red[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD="bgcolor: #DDEBF7"]Jenny[/TD]
[TD="bgcolor: #DDEBF7"]Green[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD]Dory[/TD]
[TD]Green[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD="bgcolor: #DDEBF7"]Dory[/TD]
[TD="bgcolor: #DDEBF7"]Blue[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]


first case:
Code: 
[SIZE=1]let
    Source = Excel.CurrentWorkbook(){[Name="Table12"]}[Content],
    #"Pivoted Column" = Table.Pivot(Source, List.Distinct(Source[sth1]), "sth1", "Sth2", List.Sum)
in
    #"Pivoted Column"[/SIZE]
second case:
Code: 
[SIZE=1]let
    Source = Excel.CurrentWorkbook(){[Name="Table14"]}[Content],
    #"Grouped Rows" = Table.Group(Source, {"Name"}, {{"Count", each _, type table}}),
    #"Added Custom" = Table.AddColumn(#"Grouped Rows", "Color", each Table.Column([Count],"Color")),
    #"Extracted Values" = Table.TransformColumns(#"Added Custom", {"Color", each Text.Combine(List.Transform(_, Text.From), ","), type text}),
    #"Split Column by Delimiter" = Table.SplitColumn(#"Extracted Values", "Color", Splitter.SplitTextByDelimiter(",", QuoteStyle.Csv), {"Color.1", "Color.2", "Color.3"})
in
    #"Split Column by Delimiter"[/SIZE]
Click to expand...

That is exactly what Iwant. This code you have listed, do I need to enter that somewhere? Like into a VBA table or something?
 
Upvote 0
I've tried using this. The first error I get is can't find "Table14". . . . what is Table14 in your example, do I have to define somewhere?
Is there a guide somewhere that shows what all the names inside brackets mean?
 
Upvote 0
select your range then use Alt+A+PT, copy code into PowerQuery Advanced Editor (replace with all what you see) then change the name of table in code suitably

for excel 2010/2013 you'll need PowerQuery add-in (free from MS site), for excel 2016 and higher - PowerQuery is built-in aka Get&Transform
 
Last edited:
Upvote 0
sandy666 said:
select your range then use Alt+A+PT, copy code into PowerQuery Advanced Editor (replace with all what you see) then change the name of table in code suitably

for excel 2010/2013 you'll need PowerQuery add-in (free from MS site), for excel 2016 and higher - PowerQuery is built-in aka Get&Transform
Click to expand...

I've got Excel 2016, but I'm obviously a couple of years behind your knowledge! :)

So I've got my data sitting in two columns.
I highlighted all the data, went to Data > Get Data
it appears it wants to get it from another workbook?

So I closed the workbook, and opened a new one, went to Data > Get Data and linked it to the closed workbook with my data. This gets the data into the new workbook with 2 columns and I can then open power query editor, but I can't work out the coding to put into the advanced coding. I don't know what Alt+A+PT even is. I assume Alt+A is holding the Alt key and A key together, but what is PT?

Do you know of an online guide as to how to get started with this? Like a step by step. You instructions obviously work, but I think they start at a point well beyond what I can get to. I appreciate your efforts, don't get me wrong, I just don't know where to start.
 
Upvote 0
select your "table" then : Data - From Table

edit:
press Alt then hit A and then hit P and T (this is just "From Table")
 
Last edited:
Upvote 0
sandy666 said:
here is an example excel file
Click to expand...

Absolutely Brilliant.

I haven't quite figured it out how to do it myself, however, I copied my actual data into your sample and even though I had 2900 rows of data, it picked it up and put it into the 650 unique rows I required with the 10 columns I required next to it. I edited to add in the additional beyond Colour.3 etc....

Amazing. I am so grateful. You just saved my 6 hours work!
 
Upvote 0
6 hours? so little?
rotfl2.gif


you are welcome
have a nice day :)
 
Upvote 0
You must log in or register to reply here.

Similar threads

C
  • Solved
Split into sheets based on multiple criteria
Replies
6
Views
190
cdrobinson83
C
K
  • Question Question
Stocktake of Barcoded Inventory in Excel using a Barcode Scanner
Replies
9
Views
345
Kobus Horn
K
B
  • Solved
Need code that converts colors from the RGB code to the Natural Color System (NCS)
Replies
6
Views
292
PeteWright
PeteWright
T
  • Question Question
Calculate if staff are still enrolled in tasks
Replies
2
Views
84
tigerzen
T
C
  • Question Question
Macro Help - Transposing Some Data from Columns to Rows, Accounting for Duplicate Data
Replies
1
Views
127
Kaper
Kaper

Forum statistics

Threads
1,224,767
Messages
6,180,848
Members
453,001
Latest member
coulombevin

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