alidurfani
Board Regular
 Joined
 Apr 12, 2019
 Messages
 104
 Office Version

 2016
 Platform

 Windows
Hello everyone,
I am using below formula and I don't have any problem with it but I need to do some manual formatting like deleting blank rows and deleting column B and D
I am looking for a Macro to do it automatically to get result like below
I am using below formula and I don't have any problem with it but I need to do some manual formatting like deleting blank rows and deleting column B and D
Book7  

A  B  C  D  
1  1  A  A B C D E  A B C D E  
2  B  B C D E  
3  C  C D E  
4  D  D E  
5  E  E  
6  2  A  A B C D  A B C D  
7  B  B C D  
8  C  C D  
9  D  D  
10  3  A  A B C  A B C  
11  B  B C  
12  C  C  
13  4  A  A B  A B  
14  B  B  
15  2  A  A  A  
Sheet1 
Cell Formulas  

Range  Formula  
C1:C15  C1  =IF(A1,D1,"") 
D1:D15  D1  =IF(A2,B1,B1&" "&D2) 
I am looking for a Macro to do it automatically to get result like below
Book8  

A  B  
1  1  A B C D E  
2  2  A B C D  
3  3  A B C  
4  4  A B  
5  2  A  
Sheet1 