Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

split table by empty rows into multiple tables

hello,

 

I am new to powerBi, i would like to split one table similair to this one shown below into three separate tabels based on the empty spaces.

It would seem to be somthing that can easily be done yet i cant find a simple way to do this 

name 1 
dateamount
12-12-20121
12-12-20121
12-12-20121
  
name 2  
date amount
11-11-20112
11-11-20112
11-11-20112
  
name 3  
date amount
11-11-20112
11-11-20112
11-11-20112

 

thanks for your help.