Hi Yall,
could anyone help me to make xslt transformation of the the
following xml input

<?xml version="1.0" encoding="utf-8"?> <lifeExpectancyTable> <lifeExpectancyRow> <country>Afghanistan</country> <male> <Y1990>42</Y1990> <Y2000>44</Y2000> <Y2009>47</Y2009> </male> <female> <Y1990>46</Y1990> <Y2000>48</Y2000> <Y2009>50</Y2009> </female> <bothsex> <Y1990>44</Y1990> <Y2000>46</Y2000> <Y2009>48</Y2009> </bothsex> </lifeExpectancyRow> <lifeExpectancyRow> <country>Albania</country> <male> <Y1990>65</Y1990> <Y2000>68</Y2000> <Y2009>72</Y2009> </male> <female> <Y1990>71</Y1990> <Y2000>73</Y2000> <Y2009>75</Y2009> </female> <bothsex> <Y1990>68</Y1990> <Y2000>70</Y2000> <Y2009>73</Y2009> </bothsex> </lifeExpectancyRow> <lifeExpectancyRow> <country>Algeria</country> <male> <Y1990>66</Y1990> <Y2000>68</Y2000> <Y2009>71</Y2009> </male> <female> <Y1990>69</Y1990> <Y2000>71</Y2000> <Y2009>74</Y2009> </female> <bothsex> <Y1990>67</Y1990> <Y2000>69</Y2000> <Y2009>72</Y2009> </bothsex> </lifeExpectancyRow> <lifeExpectancyRow> <country>Andorra</country> <male> <Y1990>74</Y1990> <Y2000>76</Y2000> <Y2009>79</Y2009> </male> <female> <Y1990>81</Y1990> <Y2000>83</Y2000> <Y2009>85</Y2009> </female> <bothsex> <Y1990>77</Y1990> <Y2000>80</Y2000> <Y2009>82</Y2009> </bothsex> </lifeExpectancyRow> <lifeExpectancyRow> <country>Angola</country> <male> <Y1990>38</Y1990> <Y2000>44</Y2000> <Y2009>51</Y2009> </male> <female> <Y1990>45</Y1990> <Y2000>48</Y2000> <Y2009>53</Y2009> </female> <bothsex> <Y1990>42</Y1990> <Y2000>46</Y2000> <Y2009>52</Y2009> </bothsex> </lifeExpectancyRow> </lifeExpectancyTable>

to get following xml output

<?xml version="1.0" encoding="utf-8"?> <lifeExpectancy> <male> <record year="1990" country="Afghanistan">42</record> <record year="2000" country="Afghanistan">44</record> <record year="2009" country="Afghanistan">47</record> </male> <female> <record year="1990" country="Afghanistan">46</record> <record year="2000" country="Afghanistan">48</record> <record year="2009" country="Afghanistan">50</record> </female> </lifeExpectancy>

Take a moment to read https://www.daniweb.com/programming/threads/435023/read-this-before-posting-a-question

Also you already have the output so your question is already answered by you. Maybe you had other XML files and needed an app to filter or such but your post omitted that plus didn't show your work so far. You pasted an input and output and said you wanted that output.

Since you have your output already, my guess is you forgot a lot of your other questions.