Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Merged data unmerge

Hi,

 

Can we unmerge the data with filling all rows?

e.g. Configuration has only one value of row when we get the data to query, so would like to fill all the rows with the same text 23 TRX. 

 

Need Help
Show and Tell
Tips and Tricks

3 Replies

  • PhilipTreacy's avatar
    PhilipTreacy
    Icon for Super User rankSuper User
    2 years ago

    Hi Anonymous 

     

    You want to fill the Configurations column with the text "23 TRX", but the column in your image has the text "32 TRX (AEQY) 2022 CLP" ?

     

    If so you'll need to replace that current value with "23 TRX" then you just need to right click on the Configurations column header then choose Fill Up/Fill Down.

     

    Example:

     

     

     

    Phil

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      2 years ago

      Hi, 

      I found merged rows is fine cuz it is automatically unmerge with the copied values for all the rows, 

      but the problem is merged columns. 

       

      e.g. column 21 has no value which was merged with column 20 in excel. 

       

       

       

  • PhilipTreacy's avatar
    PhilipTreacy
    Icon for Super User rankSuper User
    2 years ago

    Hi Anonymous 

     

    Not following you.  Please provide some data so I can better understand.

     

    Phil