How to create a table with columns & rows which is not pivot

[TomerIwanir1]

Hi All,

I have 1 excel file that contain columns and connected to "dates" excel,

in the excel file I have many columns, I want to create a table like the pic below :

when the rows are columns from the wxcel and the columns are coming from dates

the problem is that under regular table visual I dont have columns (reating one columns of dates)

and at pivot the rows and getting into levels,

any idea what to do? thanks

[Sri_phani]

Hi @TomerIwanir1  If I understood your concern correctly. You are looking for stepped layout in matrix visuals. Which will add new columns instead of hierachy view . Try turning off stepped layout in matrix visual. 

[Greg_Deckler]

@TomerIwanir1 Not quite sure I understand this. Maybe try a Matrix visual though. 

[TomerIwanir1]

It wont work

As matrix visual will create one row and the next one will be in hiercachy when Im looking for different rows