Forum Discussion

Copper Contributor

Oct 12, 2023

Need to fill data while keeping blank row in between

Pulled data from a different sheet to my current sheet using ='OrigSheetName'!A172. In the original sheet, the data is in numerical order "150, 151, 152" etc. I want to fill the data into the new s...

Formulas and Functions

OliverScheurich

Gold Contributor

Oct 12, 2023

=IF(MOD(ROW(A4),3)=1,INDIRECT(ADDRESS(ROW($A$172)+QUOTIENT(ROW(A3),3)-1,1,,,"OrigSheetName")),"")

You can enter this formula in any cell of the original sheet and fill it down.

Copper Contributor

Oct 12, 2023

OliverScheurich

I have corresponding data that is text that I need to pull into this sheet, too. Does this formula only work with numbers? I need to still have two rows blank and then the text from the other sheet.

OliverScheurich
Gold Contributor
Oct 12, 2023
brandie327
I'm not sure what you exactly want to do. All the data on the "OrigSheetName" Sheet is text, not numbers:

Original Sheet
Data 150
Data 151
Data 152

Maybe you can attach a screenshot which shows the data and the desired output.
- brandie327
  Copper Contributor
  Oct 12, 2023
  The original sheet has this information:
  
  Column A
  Activity #'s
  
  Column B
  Information completed during that activity (text)
  
  Sheet 2 is a detailed report combining information from that sheet but it has to be in the following format:
  Activity #
  Activity Text
  BLANK ROW
  Activity #
  Activity Text
  BLANK ROW
  
  I was able to use the first Fx for the numbers and it worked perfectly! When I tried to use it for the text, it didn't work.
  - OliverScheurich
    Gold Contributor
    Oct 12, 2023
    brandie327
    =IF(MOD(ROW(A4),3)=1,INDIRECT(ADDRESS(ROW($A$174)+
    QUOTIENT(ROW(A3),3)-1,1,,,"OrigSheetName")),IF(MOD(ROW(A4),3)=2,INDIRECT(ADDRESS(ROW($A$174)+QUOTIENT(ROW(A3),3)-1,2,,,"OrigSheetName")),""))
    
    This formula should return the desired output.

Resources