Recreate my table in pivottable

[Jyggalag]

hi guys,

i am SUPER bad at pivottables

i have this dummy data for a loan here in my sheet:

I essentially would like to create a slicer for "Status" that can filter for this table.

However, in order to do so, it seems that I have to make a pivottable?

I like my current formatting, but if I pivottable my data, it looks like utter garbage and I am completely unable to recreate the above table, even if I put "Identifier" as the row, and everything else as columns.

Can somebody help me please? Thanks!

 

[Georgiboy]

You don't need to use a pivot table to get a slicer.

You can make it a table object by selecting the range and using CTRL+T to make the range a table.
Once you have created the table object from your range you can select your table and go to 'Table Design' in the ribbon at the top, in there you will see an option to add a slicer 'Insert Slicer' when you select it - it will ask which header you would like to make the slicer from.

If you use the CTRL+T option to create the table then it should not change your current formatting.

 

[Jyggalag]

You don't need to use a pivot table to get a slicer.

You can make it a table object by selecting the range and using CTRL+T to make the range a table.
Once you have created the table object from your range you can select your table and go to 'Table Design' in the ribbon at the top, in there you will see an option to add a slicer 'Insert Slicer' when you select it - it will ask which header you would like to make the slicer from.

If you use the CTRL+T option to create the table then it should not change your current formatting.

If I do this, it removes my headers (if i press "my table has headers" and also if i press "it does not have headers")

any way to avoid this?

result at the moment:

 

[Jyggalag]

note: without headers it does keep the titles, but it looks silly with the new row above it:

 

[Georgiboy]

Are the headers still there but with white font or are the header cells blank?

 

[Jyggalag]

You don't need to use a pivot table to get a slicer.

You can make it a table object by selecting the range and using CTRL+T to make the range a table.
Once you have created the table object from your range you can select your table and go to 'Table Design' in the ribbon at the top, in there you will see an option to add a slicer 'Insert Slicer' when you select it - it will ask which header you would like to make the slicer from.

If you use the CTRL+T option to create the table then it should not change your current formatting.

Nevermind! It was because I had background color set as white, and same with text color

my bad hehe

thank you so much Georgiboy!

 

[Georgiboy]

Happy to help, glad you got it sorted.