Forum Discussion
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...
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.
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.
- 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.=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.