I have multiple rows of data for different users. Some users have multiple entries and some will only have one. All this info is stored in a '1 row per user' format. My goal is to show all this info vertically, with each user having potentially multiple lines based on how many parameters they pass.

What is the best way to go about this? Ideally, I'd like to have it set up where I can just paste new user entry rows at the bottom and have the vertical table repopulate.

I'm using O365

CodePudding user response：

This formula work for Excel 2019 and up

In Cell I2 array (CSE) formula copied across right to K2, and all copied down :

=IFERROR(FILTERXML("<a><b>"&SUBSTITUTE(TRIM(TEXTJOIN(" ",,IF(ISNUMBER($B$2:$G$4),$A$2:$A$4&" "&$B$2:$G$4,"")&IF(ISTEXT($B$2:$G$4),$B$2:$G$4,"")))," ","</b><b>")&"</b></a>","//b["&(ROW($A1)*3 COLUMN(A$1))-3&"]"),"")

Remark : In Office 365, I think it is a normal entry.

CodePudding user response：

Here is a modified version of the answer in